SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002601 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002601 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522243,1000880,352137,454131,899911,794086,745352,304597,678851,961193,68145,217744,619179,763284,563054,935564,273477,801449,722653,81237,434350,239017,339772,632023,787693,496447,574857,171022,785949,768319,229448,523543,291588,864945,750619,356677,617611,952362,585241,276337,685093,980762,587592,662919,1022282,1043051,796691,775583,531350,711981,912246,925553,1018509,414622,442267,815956,807069,157047,203970,566704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]