SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 661751 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 661751 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017521,219378,1008508,454423,541153,46326,841967,500038,110167,393053,129066,532742,583928,702756,335867,856849,941375,179875,292036,385079,83018,1042481,395888,1004489,631194,566352,103839,837364,670036,952994,981450,642097,494301,598091,639174,886080,512327,5331,89628,850970,728841,381608,21020,910353,939134,1028283,974740,281363,648987,504625,526777,460281,86326,785003,364004,475194,331401,139720,136065,418041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 661751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 661751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]