SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418094 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418094 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670085,39117,207555,499485,472150,779758,637801,386367,259082,867648,128119,1044947,871305,649707,231956,965741,644615,642354,520187,757331,493071,1037012,45238,251981,519946,487052,566096,552867,939452,620882,369365,427681,1028485,437363,1002819,272012,134689,998595,594341,271737,362997,14246,855334,524926,457157,906325,793706,918352,218105,539292,641575,454461,543063,817151,299052,925694,32740,603073,814329,837908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]