SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436045 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436045 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231487,579634,46938,106398,855766,82651,521484,835927,368964,405639,453879,162906,353482,548949,52357,619774,602939,89344,327662,925750,302548,174208,545333,985892,370281,620039,964144,983190,647870,368607,95878,811948,878556,560597,612477,447700,140521,205939,91892,343024,580261,163938,423766,434345,925324,199255,870027,904160,318047,989055,503517,1017889,654692,175935,148111,309342,723841,30591,832142,266469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000839s ]