SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330501 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330501 [ RunTime:0.007192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758353,687613,457932,652817,130105,186494,636355,503936,285005,407901,1004580,150870,1037828,674849,246534,494611,814210,579241,186120,943622,725180,922701,846192,553505,804632,455608,1032350,310828,171686,26530,406094,765077,442438,775413,187949,154354,299878,273421,974102,1043610,880072,998406,680224,477071,422939,706935,68335,330035,451313,110283,968696,1001966,144786,656850,43144,349386,150044,134974,418801,35034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001074s ]