SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478058 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478058 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6707,504500,108756,547940,507102,79223,662547,1002730,666686,21680,180558,116615,145229,625937,746887,127946,474754,128303,375655,630330,803596,505456,294180,374551,968804,454444,699940,420834,269871,719526,111580,389973,629788,533965,551743,189420,913963,89601,73615,129568,453779,1027629,620903,718451,724484,104583,537539,362365,382657,918123,785128,478464,691451,388805,1015774,233442,566292,351650,366249,672700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]