SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283551 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283551 [ RunTime:0.002611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752945,56162,1004023,446881,932494,1024273,320957,462578,290214,818627,378711,771128,630120,757587,564654,669142,62693,191856,317080,128541,317218,948003,423280,872754,353025,620296,307263,392164,959776,784874,642708,767975,490063,452256,309466,118463,654867,40915,60794,666185,777261,332994,42630,851943,644230,720020,726123,700488,542694,997966,720545,352639,207280,648333,425484,317399,993201,756793,964225,1013139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]