SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565191 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565191 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763902,326067,310267,805152,56530,650276,346505,987255,485310,813942,628783,256413,444507,71874,812391,521573,739840,706976,1038598,119999,556394,303887,227024,948468,112986,110858,927812,717914,816642,799168,986291,285977,142353,550479,395514,11512,609234,259772,961751,881389,411705,564408,306310,223951,277872,161497,63456,439780,547723,122128,18602,729887,906725,869738,635506,6381,228273,147179,981136,737367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]