SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 168715 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 168715 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540721,13978,1012011,180693,629664,225881,438590,93843,338301,339076,318852,125117,431598,1029083,580094,346307,205309,531074,45598,979852,881506,400639,483141,907732,443787,275239,1254,175607,841277,379284,783509,446361,23177,364329,43024,809324,836473,193886,462160,246365,286093,846923,184852,735859,526252,702746,162856,743138,39693,1032802,418790,30624,249910,841702,909075,810106,665726,78889,1012315,181777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 168715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 168715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]