SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416843 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416843 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827234,648531,923892,34604,62736,98935,495865,143472,598402,472071,898399,716254,482665,862529,276222,910026,434596,258972,153754,81102,300504,645703,366581,263340,573365,984356,16630,129371,1019340,846428,446066,260954,661418,719919,692063,13250,401914,366520,923431,547978,813034,83784,966958,98490,268445,85098,783745,654723,352845,309888,734639,862165,341623,371635,165861,253632,106181,1048802,692991,698637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]