SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025911 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025911 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295652,832080,670706,751670,714740,582778,226456,199600,106287,298632,643091,932993,760556,291132,347713,969306,763379,765105,1032301,949189,1007804,494828,671022,25166,366925,676638,452819,689173,875414,652958,685381,200994,599088,434585,221025,647318,197440,14003,112016,848598,218332,933070,941906,253730,410479,893778,144027,379426,180773,155740,303816,116099,947381,9240,218149,589969,104803,181280,164930,869690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]