SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403178 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403178 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487277,186549,38466,671121,504701,51822,542972,1033959,868217,238922,785941,643807,449278,312816,237553,664677,244255,623780,300096,91585,56983,210577,43594,991743,217522,966876,16119,175862,311739,983266,314864,442566,1038340,371354,509733,837319,238178,918614,332456,1026349,512668,985093,725221,249923,29808,793694,310522,584076,108696,236966,489023,111024,258172,840408,487974,896526,540953,500723,1018036,682234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]