SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285236 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285236 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352800,275906,835259,248638,929144,51988,281906,391125,731355,311752,322850,1022082,2122,14115,797028,256476,817727,696907,1039372,851728,686429,765677,80491,506577,986492,467534,741382,722571,311513,661055,11109,733944,308153,15872,613136,141243,600047,412562,25294,507897,798949,570630,547487,787158,988591,10514,161970,1041599,335308,548928,1023679,50078,33746,528636,538536,572073,634102,752690,747079,830776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]