SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499431 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499431 [ RunTime:0.002292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59094,358899,25581,285647,568735,431525,1057,460747,10577,796317,983048,1025940,906011,762033,466865,383431,202098,84472,339331,1043497,387364,427283,40049,65892,771169,461399,546226,289397,321572,310499,600708,68771,460683,128999,344732,917309,149204,502190,929606,898420,339992,102593,744112,718721,212219,889534,898229,517922,618623,799147,703297,1007000,72640,939476,601113,653178,231730,1035937,471665,516850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]