SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 679303 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 679303 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000043,763981,254073,833940,854189,462208,142067,250660,64777,108039,476854,15950,394272,160065,959363,845810,655844,376318,428673,614214,869057,457593,902821,435935,785713,697160,229437,927796,59943,931034,846660,579611,502238,436550,889055,674501,265629,402408,1014042,835657,191958,251336,78478,640432,61960,667985,447013,71692,130514,790314,1043529,542647,85193,582226,705275,303132,544214,297042,512088,124038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 679303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 679303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001109s ]