SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397178 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397178 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917234,1009518,12821,641517,705529,113526,974032,321609,296078,805315,922962,106844,945640,993526,654698,343581,582451,399622,142608,116384,434984,533464,846371,74748,194440,608059,91408,882651,93536,757505,107712,435764,1006671,675463,121248,226902,72514,264273,437784,746754,502783,456090,387058,483904,112757,532805,922937,248339,532347,738970,710079,521297,261663,301607,187782,1032449,1000574,960970,872938,320581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]