SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512751 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512751 [ RunTime:0.003097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515797,539084,16704,381382,962893,248064,83339,939188,1041665,277428,272416,280055,414422,871092,171540,495320,14268,1038493,777633,742204,332907,652775,230846,489307,721,188123,292912,616641,9557,532862,430557,499486,794400,276765,859680,688375,540529,375305,997242,194734,743039,259180,529106,706518,107133,921501,963046,968676,690564,479151,341599,867469,411522,98337,39759,10055,432134,990203,246182,95575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]