SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001246 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001246 [ RunTime:0.001377s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144202,270821,1008282,852030,823726,955435,107675,898315,465928,1020220,907531,175760,797423,851342,183538,305849,619463,751433,285487,655217,1025096,651246,959556,692428,357577,647979,440348,705812,920638,530399,240961,755184,364491,552384,111802,105267,611537,938877,322795,863994,926704,888454,674699,1048735,416018,866178,330712,452385,425541,1013364,244559,150854,574838,951803,780684,53369,100099,397147,696555,820233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]