SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122822 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122822 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534190,1006362,672832,123914,912104,379081,672661,582611,592511,838203,99249,198519,982572,410710,1026364,403818,482491,741413,943886,115628,315325,984882,973341,522815,670469,651087,248138,648285,685323,28297,149066,343183,778676,628689,818334,374088,545741,355514,348294,1024940,858020,559431,59050,873998,901399,60228,762534,336306,7423,1003202,456700,25747,498593,1036284,753081,173544,637938,215754,491761,429251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]