SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478983 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478983 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13448,299911,783399,516738,786191,1038959,16233,767800,67699,635703,1045830,949992,841938,640707,731662,136195,200638,712940,128395,65974,666685,997601,474448,390350,131875,317622,800153,2374,214488,864535,613075,508661,289096,1039890,610291,797902,49658,618952,35621,395850,488546,509430,26132,630633,1019568,991778,694879,317061,253709,729271,268988,866564,623380,750463,208606,950282,193880,389853,664717,975427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]