SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101146 LIMIT 1 [ RunTime:0.001217s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101146 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204009,622052,363366,117269,958339,28789,955995,256791,882664,642962,419972,555464,193595,916830,364586,276050,149639,360464,832618,598106,466554,1031570,667953,771124,66073,1027305,178421,610119,1009697,476079,236411,1020229,496301,761152,627184,688965,477970,300878,139014,271155,201856,152225,200109,819223,992644,807105,511169,67750,744561,870745,899862,555696,491560,863527,668920,180169,999908,904658,561907,786293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101146 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101146 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]