SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425517 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425517 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687984,596995,895968,548786,72362,144202,11823,414793,107173,198340,348600,652616,439046,860940,984260,937969,505002,255644,417915,635236,109143,459520,584205,339999,595179,1004804,475845,842581,329487,682715,502396,543884,491813,231107,912207,69373,784159,652147,51504,406611,30393,238581,543384,872114,1041592,268572,10968,722275,919353,5034,562732,197383,40408,281802,761587,941274,1009846,665158,46994,931128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]