SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191904 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191904 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494539,404446,476174,298553,502495,831803,1022384,377845,612014,476730,258660,84030,1035606,310993,171992,938244,249142,410091,967435,629201,157526,67347,665289,687710,510779,365107,694274,58109,84380,792434,631256,572036,207149,59085,810596,581002,721853,230118,76009,765746,633142,822985,119539,252850,698323,1019598,150912,239954,582877,407191,69999,338202,948001,183995,574192,610791,358034,637706,263880,155677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]