SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513103 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513103 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106039,569136,857544,440409,811063,440458,135105,745934,145227,74085,132724,615883,176006,117522,150484,257244,796278,387730,497375,993521,295815,659902,844334,492118,743437,564639,725709,619024,582167,768266,663036,351968,467138,209614,886256,882115,953292,174652,341979,829144,970577,749049,871652,80428,742644,338501,731361,281191,252298,878058,53950,117868,921713,1048745,655520,864361,47088,357787,945811,149006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]