SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499214 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499214 [ RunTime:0.002437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473644,624820,626591,831812,222363,373803,558469,774031,879045,823877,136378,471251,632507,627666,978966,809523,1013151,40424,162140,420752,380764,168829,444665,478418,34671,817148,977484,968001,349762,836624,685887,789880,764398,1029748,711895,734980,836720,693027,814341,643566,1037450,855581,318415,641794,46979,153401,540211,777890,377684,86757,183375,634453,936021,161860,607053,630472,520282,286870,623400,467171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]