SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001812s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 216013 LIMIT 1 [ RunTime:0.000566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 216013 [ RunTime:0.002134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027055,991437,631380,438364,314263,893790,332152,684531,319709,498336,211298,1012191,82918,294245,887575,952538,773885,38740,672739,712802,633587,958278,332231,248285,313316,1031193,1002010,57809,403720,87925,827593,976758,893425,1024713,166645,838130,907586,469532,198110,466284,459940,273890,197629,966198,621809,515275,517804,419486,394499,725236,1018690,654329,387088,645832,772136,912597,459617,871626,1012487,897469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 216013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 216013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]