SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10391 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10391 [ RunTime:0.003223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296680,807114,300656,955663,276339,767738,421202,80874,267001,665074,1026003,242216,780641,235345,341888,102444,660230,858581,259991,836240,597059,6083,576046,147184,496075,862106,639237,630287,717430,737340,308785,331084,321270,686600,348090,137076,930814,672087,828154,1023414,139448,134086,626477,786737,1038993,400327,503968,720662,6111,902362,928421,794661,957466,963569,707341,501073,366986,598480,748552,498804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]