SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 7308 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 7308 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148274,598832,76920,327202,64650,29448,16827,941380,399493,13183,299813,90778,439288,616768,438164,983974,23856,57453,1041843,355956,159390,19781,915775,1012018,5631,621544,613916,628693,550391,349188,384118,573314,97781,252940,352739,248369,883602,381747,975269,426016,826628,204926,579784,438424,431442,419076,304194,866754,969691,695078,989681,117729,452868,1031236,216893,467788,532561,459973,153735,529033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 7308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 7308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001061s ]