SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353511 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353511 [ RunTime:0.002168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612741,284226,787015,86564,643161,125740,773423,18467,827799,423350,52160,410649,520570,708716,691542,848567,976493,315888,52358,465095,733382,110261,347790,983014,936735,242327,568203,633022,527130,128325,359106,204516,604566,41933,1001977,670548,441289,166858,969903,973418,585865,362981,1047129,903035,461994,950086,380900,105482,224920,767294,442687,909165,820076,830962,396091,811025,374620,909582,16365,106927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]