SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901999 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901999 [ RunTime:0.002593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (654230,832619,690194,107062,944264,549028,953896,417889,145110,661732,522474,82727,1024238,291704,62865,733850,289293,326305,223363,27163,752419,176956,41141,325114,694782,9493,1036370,193031,120240,1011592,678198,11255,1003243,1015457,302964,726033,931090,225702,617770,738716,510456,7399,1030508,736594,636014,131403,529836,1043814,229065,149950,122822,401328,856792,1041909,543211,317816,851442,944399,837612,9289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]