SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042478 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042478 [ RunTime:0.001927s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599760,635620,766696,54779,798160,546069,865999,844902,15274,243192,454436,125728,357706,305810,425090,707366,864154,9580,233010,706671,398114,466698,423314,679027,8038,270439,726415,433328,239182,743860,796769,384978,593782,285347,507228,320337,588409,641868,831653,639483,895697,93524,195033,189070,1018958,595842,935081,105261,537389,266332,334841,970709,772027,1027342,135762,459694,182204,707403,931711,483936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]