SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588404 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588404 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697284,382710,484101,376221,563600,844755,202918,499560,626674,639379,561272,736358,160406,324231,900463,1026175,32137,417796,415776,411058,421817,134730,741420,950009,998714,952616,821578,151876,245487,300663,132509,65159,684346,684456,580053,967391,863294,220750,297028,409253,620453,157598,323338,49920,383156,742938,985882,165909,528798,877024,314908,271195,95,254446,325516,383518,241733,609359,288841,3711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001655s ]