SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004390 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004390 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388958,1021966,643712,970059,123791,743314,589710,757478,662899,472342,280144,899328,272016,183773,653945,524064,787130,104323,60265,962489,610606,609004,712092,778375,430501,218628,190069,440737,321028,656395,1037285,291438,9244,900198,589199,798254,982891,788639,294550,835642,314689,612905,423094,978052,165317,949679,180494,932838,143623,238572,38988,813163,967152,103269,601323,372693,832608,362163,304217,761245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]