SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112450 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112450 [ RunTime:0.002426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214181,461595,620813,6066,256338,399790,989200,618699,841825,171603,415328,439833,114621,490547,42277,200312,642390,131386,193285,883184,962242,246590,440435,691220,463808,880905,160287,365328,145111,213854,685238,633469,122058,679619,415424,724722,936327,576465,856711,494776,784571,891160,842106,446174,462923,645507,196940,757752,683100,1004294,408402,356997,471992,103193,803399,6005,19243,869077,201032,541069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]