SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340312 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340312 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283434,847230,900358,402378,36679,329775,951121,821705,101342,998127,463813,640802,747118,808688,1032822,633894,13142,647053,44294,613865,248605,224563,352216,193125,1010144,228236,58927,601090,505285,560931,644336,715385,208250,964104,203155,939433,1013718,40513,578417,943345,22395,263502,99470,1017333,440865,634096,300012,377843,682443,438640,1035070,689262,661342,520839,898824,51393,344294,858019,974371,803711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]