SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502239 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502239 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422024,496371,425833,457867,597074,35155,665257,321219,355998,343270,34944,970140,660485,1020051,232140,311122,704112,1010320,91725,1019293,972674,93872,520941,630896,937563,76951,7018,220579,255085,175844,533076,570514,603110,909018,45556,292799,463174,534611,1023553,189935,85605,913358,195727,18870,684388,1029448,120202,763187,916094,57107,390721,568283,211031,307869,660425,313754,852269,125995,323626,85764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]