SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231110 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231110 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293543,517725,433888,359358,1018989,439426,188864,235769,803003,949581,452254,417121,291049,747375,88664,922679,634049,658565,750687,383766,332817,769531,280166,904328,211972,162744,514856,85871,247632,782448,361952,788111,725393,171599,879406,94346,277027,970840,120889,873707,197096,248000,637377,551190,904888,911237,828353,392577,804201,994991,541134,375803,455185,475970,275986,1037935,245437,784542,447384,333827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]