SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471118 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471118 [ RunTime:0.001472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29659,276648,246543,673772,796072,808620,908091,1025114,779280,1012407,903241,686264,497770,61926,311061,311711,682956,395787,467558,638131,2361,229732,708352,209653,287654,544964,226552,904507,764696,913576,150673,1010102,190625,915317,748473,802263,181312,198767,318960,462662,498427,27097,323576,885667,743293,445139,523727,228604,499807,23687,1033718,676474,743333,548617,815631,297625,754994,32146,490167,525219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]