SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454928 LIMIT 1 [ RunTime:0.000916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454928 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148461,246817,866490,858082,975427,1004863,52779,236342,719268,229884,283011,387740,711656,491761,495747,569509,156879,293789,968181,370877,847287,543762,742697,238630,211731,458423,282792,19272,169792,72913,278999,202815,358268,494060,348799,471755,591496,429720,914989,856623,49793,34407,426987,510428,1029673,284373,1047678,603950,187773,453126,374199,809828,538247,217315,310260,945761,481927,31008,517444,391554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001787s ]