SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195243 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195243 [ RunTime:0.002518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568319,102787,926916,265392,28852,99828,712715,829610,463322,297754,995646,491214,433638,365012,76453,201008,135142,548026,790805,564624,891687,666694,630275,329165,336064,301417,667321,756271,764209,118749,709863,865044,403188,655768,946079,891111,491903,261138,221639,601225,629123,1037390,183996,668081,63927,718013,799707,122571,665807,758296,476533,414389,1036208,823793,979017,779904,919738,872375,238731,897906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001141s ]