SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466160 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466160 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421529,888232,44861,290590,462404,786142,601753,1037072,1035116,152076,604528,484678,610807,198282,907650,378325,72766,577513,686398,1042165,10556,469110,974529,166288,280018,500163,1030175,532920,435858,921200,922199,1018392,673220,583705,457904,248115,721142,746519,588701,895624,661702,884096,876959,125022,167571,938560,946997,117806,50922,591096,707084,644788,479661,515664,894025,90265,668071,704872,497060,279287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]