SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153643 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153643 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21021,111385,265708,435574,100615,800933,428476,615643,503128,276668,834272,171808,135251,472975,663794,265259,57399,18350,193058,152708,138618,901402,614256,862530,103534,694715,722879,774904,764661,217307,16350,740405,281257,795381,925351,660266,41963,775478,335571,219718,524927,460481,652685,717634,870015,151171,810938,406790,46712,912298,1032507,406319,587189,874542,460371,745079,306582,958320,314289,304064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001490s ]