SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405499 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405499 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816715,1028472,64202,621668,761173,912982,740872,614043,291818,291696,416503,642678,417664,198216,314417,869391,959589,106396,975523,487694,127353,635190,118048,103108,522691,606714,57368,196295,481026,288604,293165,107955,223151,648139,294570,931042,645253,316464,23675,351635,264701,384617,544092,786347,803931,18100,391307,331175,1047160,880331,6205,1045960,343219,724755,999976,521244,108441,93748,875247,641805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]