SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427843 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427843 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517243,823137,645728,507762,963494,393441,288988,798566,939879,364437,208894,132367,252524,904512,981027,1015559,577626,900286,654395,503267,675142,333112,240502,919849,849274,505443,900210,462938,345659,723148,639211,889879,629008,819172,1020580,504464,140241,945830,862183,128915,238490,803992,23312,183010,854108,922920,459689,592517,653546,377607,788299,578669,331805,398595,706739,236777,831880,302962,841894,991106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]