SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400604 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400604 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432809,1013676,16905,715292,1002346,546108,779564,750350,158124,732629,524390,521195,772933,263059,339285,120071,447775,31020,838360,476628,336084,500311,255874,453142,956996,557415,416224,642430,847417,1021360,977121,972164,363373,352810,267912,1315,755461,624822,1014174,914113,455307,456478,91738,20433,582109,869979,734015,488177,620085,54924,14986,233509,368858,398416,508205,858985,122674,366802,891424,223678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]