SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504558 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504558 [ RunTime:0.003816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172173,154137,325554,482533,339358,1045397,433294,31694,939218,919076,478849,1019539,772606,997103,732493,813868,727684,924271,727418,824538,350131,339770,284596,508142,435722,362609,730069,383477,899242,435640,193915,716387,378805,392418,423152,625104,438963,869545,821635,924314,540110,210761,102172,755318,1003342,632394,650843,218739,961071,89744,985056,862552,68931,954793,291454,313740,786517,732136,210486,402971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001341s ]