SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501936 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501936 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702265,20939,600833,512001,765855,809628,361177,3430,315566,568483,466662,943961,286463,602748,340146,666631,315320,93876,508316,808052,483964,659963,740716,16314,537795,714970,903199,645887,126181,586344,476755,492040,99345,209551,150667,278122,175966,395283,231859,141409,600008,187148,1036172,996348,334667,781405,714308,227177,991542,692513,667160,301066,781563,149731,255369,601475,183861,804411,221250,803898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]