SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532097 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532097 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72245,126480,1040913,838715,869902,299497,608852,792102,554066,720844,166060,145660,84626,370064,713043,727578,52330,485885,557581,1033383,443113,334101,690203,291849,446521,361558,68257,530930,245055,876845,30558,826232,152410,202391,615017,680996,98522,158011,359237,215442,853619,277816,670194,836641,560637,186595,100399,514035,729089,71000,442142,857740,67787,360403,912635,394728,32628,114810,354682,528161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001797s ]