SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144540 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144540 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18986,615065,77612,477524,1026200,734111,197408,640317,99255,377483,365756,253182,899723,398438,38944,928356,728514,50479,284850,1028035,814790,696188,596999,328597,925609,642592,424268,413938,849920,901816,365711,9573,281646,121630,475581,887846,795670,16299,476554,852027,863596,155602,117301,326910,594055,561323,998478,170386,45347,377998,275175,239195,146108,315192,39933,554238,1028567,389175,212212,384107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]