SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301823 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301823 [ RunTime:0.002616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183102,864130,10524,836876,884704,327505,854749,435065,692561,176644,161215,576577,701388,6643,535244,11306,411909,268945,445359,788743,570099,436641,582887,218227,768569,548261,251718,93718,991905,445052,762974,705265,45015,748158,282366,31889,46844,785283,704997,840434,909532,811646,614197,514697,542327,334938,493570,869470,264361,804034,923016,368874,281231,723550,645901,30537,1041214,168487,844479,853295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]