SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020118 LIMIT 1 [ RunTime:0.001277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020118 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71514,802468,837509,442951,467285,439708,657761,1015748,163916,986383,220786,202283,374412,969206,652936,402959,694911,250032,262862,127944,43605,325665,441274,464586,984884,952934,476414,498123,3733,601383,125172,511751,444243,912607,178549,517041,426609,239636,931686,344105,363039,448676,695457,742206,1030496,125701,822276,604512,77243,544397,794349,517935,1012394,948031,800444,429100,552090,223797,574144,606765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]