SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199808 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199808 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356909,752064,348620,242479,515899,118503,111577,308940,422371,606,644361,763887,994045,212579,15104,162198,1047415,67799,475976,417605,783767,812563,186990,1008200,155098,758415,792416,371970,930384,952682,751006,625828,203868,330744,797315,902318,611395,291374,79974,1005936,622721,710531,140184,1011997,151559,14506,605423,288365,979684,708110,243817,147013,794028,963035,367364,667990,686231,208430,560204,518502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]