SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54981 LIMIT 1 [ RunTime:0.001113s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54981 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384772,610341,523638,325518,30738,912641,625355,535999,976517,810654,849137,603308,359251,687441,338405,703778,313992,158423,169670,906735,844200,207820,41653,474802,427120,436619,497523,981669,635676,74927,324990,667387,162688,819362,482944,903622,153057,1013620,637149,223596,409615,43717,695164,1045795,761163,260437,48044,473613,1020506,22667,823097,52924,649340,617273,243509,688789,739725,777782,333449,774152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001776s ]