SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504035 LIMIT 1 [ RunTime:0.002325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504035 [ RunTime:0.006210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030496,753066,999195,438523,406442,574499,329818,1047038,741649,846137,724798,712264,614326,195666,779818,341296,421633,860084,375089,209993,265522,540007,427865,576583,867321,540393,155595,35338,781926,661742,338349,321320,966014,409396,948136,881786,618700,982352,939880,41128,599542,888217,861916,762286,637772,685312,849226,603135,481851,11560,743168,933922,685107,644652,1007290,960641,194216,187188,486401,1000624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]