SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145535 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145535 [ RunTime:0.002654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300194,344860,16658,767893,578825,716624,280413,698710,575862,32073,1027671,1005919,607733,109381,739379,94350,541222,12441,689342,944033,411254,488390,678790,723741,413810,534551,584071,389222,563867,25448,532083,775025,276978,645378,845674,694727,838250,379448,899710,953816,856255,218725,639269,455187,841722,272291,341490,839623,27919,100861,134740,352654,876110,895364,496181,760237,527354,148967,981727,881590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]