SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292828 LIMIT 1 [ RunTime:0.000880s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292828 [ RunTime:0.003546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317953,315159,987393,407094,798003,673890,344744,728191,25819,541724,831033,886189,503965,938020,193046,615983,33575,776573,544359,973143,108986,840900,50716,159193,663543,151738,907377,866272,773541,99679,630580,510854,590769,235281,829957,997852,247434,856709,702379,678056,663931,366354,980403,509077,402813,550754,347269,753685,874200,993723,150477,931925,295578,496405,368066,237380,441265,554095,197347,106091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]