SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480880 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480880 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995287,375657,641750,858619,1026028,900049,776209,915103,915692,968248,497805,950601,687792,50718,382219,171329,673783,268469,788689,189530,821063,462844,429817,193006,238483,265087,674376,503705,596726,478811,372381,366463,705888,326818,296504,981537,498008,421188,421548,193829,493436,722384,1005359,443522,906412,715162,328868,280192,929689,167890,829543,489359,790380,442145,811172,206939,523125,123535,395680,864785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]