SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356249 LIMIT 1 [ RunTime:0.000883s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356249 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253369,44805,88266,39641,413504,638263,588795,690222,100534,897594,342639,503568,210341,72686,401155,932335,8874,931478,905102,461207,449597,834397,670105,797076,342926,248987,834798,567501,777528,359146,593577,47717,470907,86568,250623,1003300,211753,477232,539996,160746,911142,751365,816832,31229,51243,927772,900356,288024,468491,140753,375054,1021164,201097,105533,368142,771402,720537,1004445,653074,4678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]