SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459816 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459816 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044305,359202,44052,659491,56800,555651,732128,757575,713443,437119,1045727,479654,584144,39324,6992,538139,359178,792710,238715,21233,297589,661892,214475,520752,516906,10740,186524,766520,618680,340988,331268,933553,792450,778863,85437,131930,135511,1022761,498099,443453,410650,311291,203048,364887,625168,359098,75047,755629,30395,718963,116845,498765,516430,514846,45099,291920,217989,166669,509509,1022530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]