SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420412 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420412 [ RunTime:0.002560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952195,403797,362247,894319,143177,802228,561396,22155,8055,470301,795497,205016,1046581,824907,967020,515893,1043486,787921,243299,17834,264198,148229,889318,406920,140099,561437,345389,987071,667156,329084,569969,343571,663913,512228,760711,252876,786188,783236,803994,531738,1015389,287639,562239,266224,186112,498120,125161,986052,578259,915499,991672,435918,948333,612404,830172,327562,767814,667439,922364,267702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]