SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432053 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432053 [ RunTime:0.001422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368577,492330,254096,107971,540488,175538,546224,404831,1004786,399245,927085,373145,778265,329247,155727,255514,251381,571339,812577,280729,730316,726083,722831,1005644,418182,107457,695055,417668,761724,429109,319514,146742,258209,948492,199285,133391,475810,246438,855127,230583,290713,501424,657880,433798,577281,421958,735867,1027970,378286,970199,714506,113810,291285,168406,704178,335360,66816,68327,306099,559123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000821s ]