SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819561 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819561 [ RunTime:0.002910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39013,817941,565094,19944,852037,996965,543448,156664,533594,96036,19674,321906,254754,216928,644147,27991,461597,5897,1025232,533791,620480,105582,656523,241305,331363,321784,1025608,265200,13110,42638,715009,121225,332223,559289,76081,435949,614681,37974,707928,839542,122379,907259,647249,589991,460360,1019028,706740,688286,212611,252299,574167,679659,15682,875163,948510,391468,995851,527565,316048,746096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]