SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505878 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505878 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235302,420622,814340,914716,56963,994528,648952,462173,79424,85731,1037006,1012985,889429,723170,731300,329314,522449,315826,814637,512986,380435,805916,972547,114677,807384,356743,611242,631461,547392,790147,936332,447521,41061,187885,618570,161975,434640,431533,90999,270408,1004290,571835,1011025,669360,1037076,413076,724334,831326,591121,704182,245662,662733,678711,552689,42503,267868,584963,975310,479965,330773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]