SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001689s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475120 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475120 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223076,128097,271860,137616,257514,979206,402893,449088,448028,786889,692745,898781,1005557,903047,390977,1045269,971621,942285,302514,533896,447996,607021,361739,865171,730681,934248,740123,226703,700948,965101,473328,424849,159694,666155,367062,170303,900143,649328,426720,1019810,944176,831317,608868,329324,247665,482897,836647,329104,165399,31411,898045,968842,860874,672619,577052,751015,452352,567576,115965,436259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]