SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543726 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543726 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785084,396125,120018,167039,364218,219587,303959,1013643,82527,385136,223439,892040,925024,570143,208340,287996,882699,51424,914501,301612,111818,143136,377169,807833,978182,567999,109016,680022,861408,938294,940878,29197,355950,703569,536463,399474,116827,216070,712187,951959,23731,501471,491801,291839,625851,1012811,541340,477338,286403,979388,4999,1012830,390189,182158,697932,231661,383152,1004996,1047058,170767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001653s ]