SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484216 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484216 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79147,318127,612159,979684,65971,318488,366815,639564,106587,483571,621379,321761,880589,490868,627883,629710,166076,325736,1010794,448122,793204,287216,1010328,164526,760251,112494,494115,763179,156312,543779,201811,174200,557002,350878,860785,53596,151206,756421,487068,428712,856013,17845,16890,331452,989269,823804,378001,405132,582070,938581,959486,60928,322706,589527,354652,424325,733095,935409,392850,967781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]