SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438404 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438404 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764294,823047,877505,753621,662806,951784,578816,810291,356518,1035701,492749,943904,498670,503020,135751,88071,572486,843769,198894,202363,755265,130487,519387,977557,929618,374615,145917,524397,968545,47110,896088,240466,290041,255646,388636,388068,136831,511098,856134,492203,880655,889409,765534,393281,823712,658806,199754,367671,431041,858248,150412,378960,326129,86395,617641,10166,457515,563758,267015,520045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]