SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107683 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107683 [ RunTime:0.004002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185276,180889,104443,222274,505122,709952,182619,243094,1010340,51123,538665,762186,958904,415308,362184,855368,610942,65350,1030805,28128,422803,710799,209198,892128,704167,588939,338583,185668,381910,1024433,376761,160481,179707,326645,719880,713979,152567,796772,1035566,649392,769976,740698,457107,768275,638014,545261,282840,15739,557024,21962,525108,73983,713992,924393,37459,131795,138576,989940,265682,782733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]