SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468308 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468308 [ RunTime:0.002776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434401,830030,83494,179914,494451,639029,218399,309203,72670,821266,232138,622666,356841,398934,697604,661709,962863,126882,306958,772369,117623,350709,730077,12419,415901,122207,537585,628150,481756,979607,739431,429177,953567,332834,258463,247955,486053,147363,207157,1047512,12692,566911,31733,157960,283310,708028,8826,591902,46172,577562,103772,116390,56956,189316,58709,418286,67412,409563,4405,47450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]