SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480544 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480544 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927167,419194,894401,314041,802616,324009,480188,1020456,704416,968438,35205,13630,725417,361757,830777,427233,275342,45692,599937,849464,542417,745945,944791,248929,560856,1009629,596025,204473,441799,536259,12343,445045,729281,982731,832723,976750,944861,957808,36115,587875,1033744,797488,726447,108344,537530,545732,809268,710532,137193,803677,354490,991760,354503,443248,482554,694417,206844,629181,491530,435197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]