SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146713 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146713 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144911,938095,838446,49186,942318,440620,912256,907004,260183,209725,907593,799042,996009,380510,235493,677871,1005004,922342,527948,822522,923679,833270,328120,638907,157069,642814,457129,61003,530671,849764,375153,85408,575665,824062,643218,757284,704396,1638,970790,825129,820719,159499,925056,1031545,235187,336390,266611,274302,97162,796393,289467,816264,931111,565645,131911,378824,197354,80110,539295,418266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]